﻿USE CORINA_PROD
GO

CREATE TABLE t_device (
    Id INT PRIMARY KEY IDENTITY,
    DeviceSn VARCHAR(50),
    DeviceKindId INT DEFAULT(0),
    RatePrice FLOAT DEFAULT(0),
	ManufactureDate DATETIME,
    DataTransferTypeId INT DEFAULT(0)
)